<?php
/**
 * SQL_Maker_Mysql
 *
 * PHP version 5
 *
 * LICENSE:
 *
 * Copyright (c) 2012, sink <sink.cup@gmail.com>
 * All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions
 * are met:
 *
 *    * Redistributions of source code must retain the above copyright
 *      notice, this list of conditions and the following disclaimer.
 *    * Redistributions in binary form must reproduce the above copyright
 *      notice, this list of conditions and the following disclaimer in the
 *      documentation and/or other materials provided with the distribution.
 *    * The names of the authors may not be used to endorse or promote products
 *      derived from this software without specific prior written permission.
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS
 * IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO,
 * THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
 * PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR
 * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
 * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
 * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR
 * PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY
 * OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
 * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
 * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *
 * @category sql maker
 * @package  SQL_Maker
 * @author   sink <sink.cup@gmail.com>
 * @license  http://opensource.org/licenses/bsd-license.php New BSD License
 * @version  SVN: $Id: Request2.php 324936 2012-04-07 07:49:03Z avb $
 * @link     http://pear.php.net/package/SQL_Maker/
 */

final class SQL_Maker_Mysql extends SQL_Maker_Base
{
    protected $char = array(
        'identifier_quote' => '`',
        'value_quote' => '\'',
    );

    /**
     * sql mode
     * @var  array
     */
    private static $sql_mode = array(
        'ansi' => array(
            'identifier_quote' => '"',
            'value_quote' => '\'',
            'end' => ';',
        ),
    );

    protected $conf = array(
        'api' => 'pdo',
        'table_name' => '',
    );

    public function __construct($db_connent, array $conf = array())
    {
        parent::__construct($db_connent, $conf);
        //mysql default sql_mode is empty
        if(isset($conf['sql_mode'])&&!empty($conf['sql_mode'])) {
            if(isset($this->sql_mode[$conf['sql_mode']])) {
                $this->char = $this->sql_mode[$conf['sql_mode']];
            }
        }
    }

    public function limit($limit_start, $limit_size)
    {
        return ' LIMIT ' . intval($limit_start) . ',' . intval($limit_size);
    }

    protected function quote($data)
    {
        switch ($this->conf['api']) {
            case 'pdo':
                return $this->db->quote($data);
                break;
            case 'mysqli':
                return $this->char['value_quote'] . $this->db->real_escape_string($data) . $this->char['value_quote'];
                break;
            default :
                throw new SQL_Maker_Exception();
        }
    }

    public function quoteColumn($data)
    {
        return $this->quoteIdentifier($data);
    }

    /**
     * @todo escape indentifier
     */
    public function quoteIdentifier($data)
    {
        return $this->char['identifier_quote'] . $data . $this->char['identifier_quote'];
    }
    
    public function quoteTableName()
    {
        return $this->quoteIdentifier($this->conf['table_name']);
    }
}
?>
